<?php
$db_alias="LOCALHOST_WEBDB";

$seat_col_num=14;
$seat_row_num=10;

$seat_teacher="5-1,5-2";


$seat_set=array(1=>array(14=>-1,13=>-1,12=>-1,11=>-1,10=>-1,9=>-1,8=>-1,7=>-1,6=>-1,5=>-1,4=>-1,3=>-1,2=>-1,1=>-1),
                   array(14=>-1,13=>-1,12=>-1,11=>-1,10=>-1,9=>-1,8=>-1,7=>-1,6=>-1,5=>-1,4=>-1,3=>-1,2=>-1,1=>-1),
                   array(14=>-1,13=>-1,12=>-1,11=>-1,10=>-1,9=>-1,8=>-1,7=>-1,6=>-1,5=>-1,4=>-1,3=>-1,2=>-1,1=>-1),
                   array(14=>-1,13=>-1,12=>-1,11=>-1,10=>-1,9=>-1,8=>-1,7=>-1,6=>-1,5=>-1,4=>-1,3=>-1,2=>-1,1=>-1),
                   array(14=>-1,13=>-1,12=>-1,11=>-1,10=>-1,9=>-1,8=>-1,7=>-1,6=>-1,5=>-1,4=>-1,3=>-1,2=>-1,1=>-1),
                   array(14=>-1,13=>-1,12=>-1,11=>-1,10=>-1,9=>-1,8=>-1,7=>-1,6=>-1,5=>-1,4=>-1,3=>-1,2=>-1,1=>-1),
                   array(14=>-1,13=>-1,12=>-1,11=>-1,10=>-1,9=>-1,8=>-1,7=>-1,6=>-1,5=>-1,4=>-1,3=>-1,2=>-1,1=>-1),
                   array(14=>-1,13=>-1,12=>-1,11=>-1,10=>-1,9=>-1,8=>-1,7=>-1,6=>-1,5=>-1,4=>-1,3=>-1,2=>-1,1=>-1),
                   array(14=>-1,13=>-1,12=>-1,11=>-1,10=>-1,9=>-1,8=>-1,7=>-1,6=>-1,5=>-1,4=>-1,3=>-1,2=>-1,1=>-1),
                   array(14=>-1,13=>-1,12=>-1,11=>-1,10=>-1,9=>-1,8=>-1,7=>-1,6=>-1,5=>-1,4=>-1,3=>-1,2=>-1,1=>-1));

if(isset($_REQUEST["week_day"])){
    $stu_query_sql="select seat_name,0 as seat_no,b.ppe_id,ppe_name,dept_no from rso_seat_fix a,school_people b ";
    $stu_query_sql=$stu_query_sql . "where a.stu_id=b.ppe_id and a.week_day=" . $_REQUEST["week_day"] . " union select seat_name,";
    $stu_query_sql=$stu_query_sql . "seat_no,d.ppe_id,ppe_name,dept_no from rso_seat_order c,school_people d where ";
    $stu_query_sql=$stu_query_sql . "c.stu_id=d.ppe_id and c.order_date='" . $_REQUEST["order_date"] . "'";
}
?>
